-- @owner: danny20001210
-- @date: 2025-5-15
-- @testpoint:验证xmltype模块dml操作正确，success
@conn PrimaryDbAmode;
drop table if exists test_xmltype_1087931;
create table test_xmltype_1087931(id int, d xmltype);
--1.插入数据
insert into test_xmltype_1087931 values(1,'abc');
insert into test_xmltype_1087931 values(2,'<test>abc</test>');
insert into test_xmltype_1087931 values(3,'abc \153\154\155 \052\251\124');

--2.查询数据
select * from test_xmltype_1087931 order by id;

--3.修改数据
update test_xmltype_1087931 set d='abc11' where id=1;
select * from test_xmltype_1087931 order by id;

--4.修改数据
update test_xmltype_1087931 set d=' <foo>abc</foo><bar>123</bar>' where id=3;

--5.查询数据
select * from test_xmltype_1087931  order by id;

--6.删除数据
delete from test_xmltype_1087931 where id=1;
select * from test_xmltype_1087931 order by id;

--7.删除数据
delete from test_xmltype_1087931 where id=2;
select * from test_xmltype_1087931 order by id;

drop table if exists test_xmltype_1087931;

